package com.lazy.dbdemo.service;

/** 
 * 定义常量sql
 * 
 * @author luodan
 *
 */
public final class JdbcSql {
    //获取数据库服务时间
    public final static String GET_DB_SYS_TIME = "select sysdate from dual";
    
    public final static String QUERY_CURRENT_GPS_SDDL = "select HOSTNO as vehicleNo,POS_TIME as gpsTime,POS_LONG as lon,POS_LAT as lat," +
            "  POS_SPEED as speed,POS_ANGLE as direction,STATUS_UPDATETIME as dbSysTime " +
            "from gpsuser.v_yzga_gps_curstatus a " +
            "where (hostno like '苏%' or hostno like 'WJ苏%') " +
            "  and status_updatetime > ? ";
    
    public final static String QUERY_HOST_CURSTATUS = "select HOSTID, HOSTNO,POS_TIME as POSTIME, POS_LAT as poslat, POS_LONG as posLong, POS_SPEED as posSpeed from host_curstatus";
}
